package com.oceanread.cn.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oceanread.cn.entity.Turbine;
import com.oceanread.cn.entity.Turbinelist;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface TurbinelistMapper extends BaseMapper<Turbinelist> {
    List<Turbinelist> getall();

    List<Turbinelist> query(@Param("start") int start, @Param("end") int end, @Param("key") String key, @Param("value") String value);
    List<Turbinelist> equal( @Param("key") String key, @Param("value") String value);

    List<Turbinelist> getTablelist(@Param("start") int start, @Param("end") int end);

    Integer getnum();

    Integer getnumquery(@Param("key") String key, @Param("value") String value);

    int insert(@Param("PrjCode") String PrjCode,
               @Param("Name") String Name,
               @Param("Num") String Num,
               @Param("Region") String Region,
               @Param("Datetime") String Datetime,
               @Param("Lon") String Lon,
               @Param("Lat") String Lat,
               @Param("Height") String Height
    );

    Integer update(@Param("SYSID") Integer SYSID,
                   @Param("PrjCode") String PrjCode,
                   @Param("Name") String Name,
                   @Param("Num") String Num,
                   @Param("Region") String Region,
                   @Param("Datetime") String Datetime,
                   @Param("Lon") String Lon,
                   @Param("Lat") String Lat,
                   @Param("Height") String Height
    );

    Integer delete(@Param("SYSID") int SYSID);
}
